insert overwrite table jms_dwd.dwd_tab_reback_transfer_express_base
select
    waybill_no
    ,transfer_waybill_no
    ,apply_type_code
    ,apply_type_name
    ,express_type_id
    ,express_type_code
    ,express_type_name
    ,package_charge_weight
    ,total_freight
    ,settlement_code
    ,settlement_name
    ,new_package_charge_weight
    ,new_total_freight
    ,new_settlement_id
    ,new_settlement_code
    ,new_settlement_name
    ,sender_name
    ,sender_mobile_phone
    ,sender_telphone
    ,sender_province_id
    ,sender_province_name
    ,sender_city_id
    ,sender_city_name
    ,sender_area_id
    ,sender_area_name
    ,sender_township
    ,sender_street
    ,sender_detailed_address
    ,receiver_name
    ,receiver_mobile_phone
    ,receiver_telphone
    ,receiver_province_id
    ,receiver_province_name
    ,receiver_city_id
    ,receiver_city_name
    ,receiver_area_id
    ,receiver_area_name
    ,receiver_township
    ,receiver_street
    ,receiver_detailed_address
    ,new_sender_name
    ,new_sender_mobile_phone
    ,new_sender_telphone
    ,new_sender_province_id
    ,new_sender_province_name
    ,new_sender_city_id
    ,new_sender_city_name
    ,new_sender_areaid
    ,new_sender_areaname
    ,new_sender_township
    ,new_sender_street
    ,new_sender_detailed_address
    ,new_receiver_name
    ,new_receiver_mobile_phone
    ,new_receiver_telphone
    ,new_receiver_province_id
    ,new_receiver_province_name
    ,new_receiver_city_id
    ,new_receiver_city_name
    ,new_receiver_area_id
    ,new_receiver_areaname
    ,new_receiver_township
    ,newreceiver_street
    ,newreceiver_detailed_address
    ,abnormal_reg_network_id
    ,abnormal_reg_network_name
    ,apply_network_id
    ,apply_network_code
    ,apply_network_name
    ,apply_staff_code
    ,apply_staff_name
    ,apply_source
    ,apply_source_name
    ,examine_staff_name
    ,examine_staff_code
    ,examine_network_id
    ,examine_network_code
    ,examine_network_name
    ,examine_time
    ,apply_time
    ,status
    ,status_name
    ,reback_transfer_network_id
    ,reback_transfer_network_code
    ,reback_transfer_network_name
    ,sender_network_name
    ,sender_network_code
    ,sender_network_id
    ,print_flag
    ,print_count
    ,revoke_code
    ,revoke_name
    ,revoke_time
    ,revoke_network_name
    ,revoke_network_code
    ,revoke_network_id
    ,reject_name
    ,reject_time
    ,reason
    ,reject_network_name
    ,reject_network_code
    ,reject_network_id
    ,entry_type
    ,transfer_reason
    ,reback_reason
    ,reback_transfer_reason
    ,dispatch_code
    ,dispatch_name
    ,goods_type_id
    ,goods_type_code
    ,goods_type_name
    ,parcel_number
    ,package_length
    ,package_wide
    ,package_high
    ,box_number
    ,cod_need
    ,cod_money
    ,insured
    ,insured_amount
    ,print_time
    ,print_user_name
    ,print_user_code
    ,print_user_id
    ,print_network_name
    ,print_network_code
    ,print_network_id
    ,pick_finance_name
    ,pick_finance_code
    ,pick_finance_id
    ,order_source_code
    ,customer_order_id
    ,origin_id
    ,origin_code
    ,origin_name
    ,destination_id
    ,destination_code
    ,destination_name
    ,is_real_name
    ,real_name
    ,id_no_type
    ,id_no
    ,sex
    ,customer_id
    ,customer_code
    ,customer_name
    ,send_code
    ,send_name
    ,paid_mode_id
    ,paid_mode_code
    ,paid_mode_name
    ,new_insured
    ,new_insured_amount
    ,new_terminal_dispatch_code
    ,is_need_receipt
    ,apply_network_type_id
    ,terminal_dispatch_code
    ,origin_network_flag
from jms_ods.tab_reback_transfer_express
where dt = '{{ execution_date | cst_ds }}'
;